Querying the database using Schema-free SQL
نویسنده
چکیده
Shema-free SQL takes into consideration two relaxations 1. Schema Relaxation: Users need not have to specify the exact name of the tables and attributes • Join Path: users need not have to specify the join path in the query Reducing user workload of writing SQL queries and knowing the complete database schema to query the RDBMS in order to get desired results Generation of Join Network (Interpretation of SQL) Select a single relation tree node as a join network and keep expanding them to create a join network. While expanding I.e. joining nodes with the help of edges, nodes and viewgraphs are taken into consideration. 1. Potential Estimation: For pruning purpose 2. Legality Test: Use of Rightmost Path Expansion to avoid generating isomorphic graphs, i.e. expanding the network(graph) only from the newly added child node to the parent node. 3. Top K MTJN are generated and the corresponding SQL queries are generated
منابع مشابه
Object-Oriented Querying of Existing Relational Databases
In this paper, we present algorithms which allow an object-oriented querying of existing relational databases. Our goal is to provide an improved query interface for relational systems with better query facilities than SQL. This seems to be very important since, in real world applications, relational systems are most commonly used and their dominance will remain in the near future. To overcome ...
متن کاملObject-Oriented Querying of Existing Relations Databases
In this paper, we present algorithms which allow an object-oriented querying of existing relational databases. Our goal is to provide an improved query interface for relational systems with better query facilities than SQL. This seems to be very important since, in real world applications, relational systems are most commonly used and their dominance will remain in the near future. To overcome ...
متن کاملQuerying Heterogeneous Databases Using Standardized Schemas and SQL
Making databases available for querying both within and across organizations is a vision held by many. Realizing this vision, however, is usually hampered by the existence of heterogeneous database systems, heterogeneous query languages and heterogeneous data semantics. What is needed is a uniform method for accessing these databases. This paper presents a standards based approach in which SQL ...
متن کاملCooperative Relational Database Querying Using Multiple Knowledge Bases
Copyright © 1999, American Association for Artificial Intelligence (www.aaai.org). All rights reserved. +On sabbatical leave at University of Florida, IFAS-IT Abstract We present in this paper an approach for providing cooperativeness in database querying using artificial intelligence techniques. The main focus is a cooperative interface that assists non-experienced and casual users in extracti...
متن کاملMultidatabase Querying by Context
The overwhelming acceptance of the SQL standard [10] has curtailed continuing research work in relational database query languages and processing. Since all commercial relational database systems conform with the SQL standard, there is little motivation for developing new query languages. Despite its benefits and wide-spread acceptance, SQL is not a perfect query language. Complex database sche...
متن کامل